from django.db import models

# Create your models here.
class Data51JobShe(models.Model):
    data_id = models.AutoField(db_column='Data_Id', primary_key=True)  # Field name made lowercase.
    job_title = models.CharField(db_column='Job_Title', max_length=100)  # Field name made lowercase.
    job_type = models.CharField(db_column='Job_Type', max_length=100)  # Field name made lowercase.
    job_place = models.CharField(db_column='Job_Place', max_length=45)  # Field name made lowercase.
    add_time = models.CharField(db_column='Add_Time', max_length=45)  # Field name made lowercase.
    recruit_way = models.CharField(db_column='Recruit_Way', max_length=45)  # Field name made lowercase.
    job_duties = models.CharField(db_column='Job_Duties', max_length=2000)  # Field name made lowercase.
    job_requirement = models.CharField(db_column='Job_Requirement', max_length=2000)  # Field name made lowercase.
    job_pay = models.CharField(db_column='Job_Pay', max_length=45)  # Field name made lowercase.
    company_name = models.CharField(db_column='Company_Name', max_length=100)  # Field name made lowercase.
    num_people = models.CharField(db_column='Num_People', max_length=45)  # Field name made lowercase.
    work_experience = models.CharField(db_column='Work_Experience', max_length=45)  # Field name made lowercase.
    academic = models.CharField(db_column='Academic', max_length=45)  # Field name made lowercase.
    job_boon = models.CharField(db_column='Job_Boon', max_length=1000)  # Field name made lowercase.
    company_type = models.CharField(db_column='Company_Type', max_length=45)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'data_51job_she'


class DataLagou(models.Model):
    data_id = models.AutoField(db_column='Data_Id', primary_key=True)  # Field name made lowercase.
    page_link = models.CharField(db_column='Page_Link', max_length=100)  # Field name made lowercase.
    take_time = models.DateTimeField(db_column='Take_Time')  # Field name made lowercase.
    word_num = models.IntegerField(db_column='Word_Num')  # Field name made lowercase.
    jobtitle = models.CharField(db_column='jobTitle', max_length=100)  # Field name made lowercase.
    jobplace = models.CharField(db_column='jobPlace', max_length=45)  # Field name made lowercase.
    jobsalary = models.CharField(db_column='jobSalary', max_length=45)  # Field name made lowercase.
    jobexperience = models.CharField(db_column='jobExperience', max_length=45)  # Field name made lowercase.
    jobeducation = models.CharField(db_column='jobEducation', max_length=45)  # Field name made lowercase.
    jobtype = models.CharField(db_column='jobType', max_length=45)  # Field name made lowercase.
    jobpubtime = models.CharField(db_column='jobPubTime', max_length=45)  # Field name made lowercase.
    jobbenefits = models.CharField(db_column='jobBenefits', max_length=45)  # Field name made lowercase.
    jobdescription = models.CharField(db_column='jobDescription', max_length=2000)  # Field name made lowercase.
    jobkeyword = models.CharField(db_column='jobKeyWord', max_length=45)  # Field name made lowercase.
    companyname = models.CharField(db_column='companyName', max_length=45)  # Field name made lowercase.
    companymanylink = models.CharField(db_column='companyManyLink', max_length=45)  # Field name made lowercase.
    companytype = models.CharField(db_column='companyType', max_length=45)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'data_lagou'


class DataXiaomi(models.Model):
    data_id = models.AutoField(db_column='Data_Id', primary_key=True)  # Field name made lowercase.
    job_title = models.CharField(db_column='Job_Title', max_length=100)  # Field name made lowercase.
    job_type = models.CharField(db_column='Job_Type', max_length=100)  # Field name made lowercase.
    job_place = models.CharField(db_column='Job_Place', max_length=45)  # Field name made lowercase.
    add_time = models.CharField(db_column='Add_Time', max_length=45)  # Field name made lowercase.
    recruit_way = models.CharField(db_column='Recruit_Way', max_length=45)  # Field name made lowercase.
    recruit_place = models.CharField(db_column='Recruit_Place', max_length=45)  # Field name made lowercase.
    job_duties = models.CharField(db_column='Job_Duties', max_length=2000)  # Field name made lowercase.
    job_requirement = models.CharField(db_column='Job_Requirement', max_length=2000)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'data_xiaomi'


class DataXiaomiShe(models.Model):
    data_id = models.AutoField(db_column='Data_Id', primary_key=True)  # Field name made lowercase.
    job_title = models.CharField(db_column='Job_Title', max_length=100)  # Field name made lowercase.
    job_type = models.CharField(db_column='Job_Type', max_length=100)  # Field name made lowercase.
    job_place = models.CharField(db_column='Job_Place', max_length=45)  # Field name made lowercase.
    add_time = models.CharField(db_column='Add_Time', max_length=45)  # Field name made lowercase.
    recruit_way = models.CharField(db_column='Recruit_Way', max_length=45)  # Field name made lowercase.
    job_duties = models.CharField(db_column='Job_Duties', max_length=2000)  # Field name made lowercase.
    job_requirement = models.CharField(db_column='Job_Requirement', max_length=2000)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'data_xiaomi_she'